SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438362 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438362 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539144,519880,553933,997050,697240,577145,662770,1026884,612254,119545,931424,285395,430915,18744,204131,97690,385558,400338,4493,683040,605405,673599,14193,550335,513188,146555,584994,936277,527772,484793,452370,952373,33000,510666,3152,551526,828229,462139,275486,507841,796386,553801,931903,777160,593945,534184,530814,797314,423511,721265,884043,1017218,42064,436731,547176,215438,818550,295215,903786,687995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]