SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300023 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300023 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80236,626383,584730,604814,653601,1040110,417523,59574,484188,167256,754001,470708,29538,287249,292984,810113,408017,287258,258249,683919,561093,846628,941272,917517,399307,479528,269750,280229,646649,898076,219814,781288,1036094,408284,54778,446148,833457,544604,180613,499617,244497,1023578,3620,820790,368105,150547,14590,568523,528891,967904,873635,1002698,402602,235585,82374,659712,683277,475248,383937,932738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]