SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428907 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428907 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954317,165631,738820,129472,776199,76645,80088,914898,389162,803757,624740,721596,70335,142919,664711,205985,213853,266431,770556,44938,672014,328278,720338,123940,445415,893325,701468,697859,405426,124123,595973,1007507,126433,375898,286410,808883,233888,963627,587123,419903,338747,648499,301495,937541,979301,708659,960598,649698,786038,617700,867002,587489,684238,498564,422180,1040333,900606,649767,220623,626600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]