SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408015 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408015 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897760,968444,464058,1005356,248474,420405,584971,641571,1022733,819433,218362,800059,310406,176688,188193,333734,495105,849764,805228,625555,689229,964171,563755,307242,202393,487858,856793,121257,205587,160802,956517,506831,656121,509954,446907,763581,929252,744439,775403,993838,877888,83037,93751,905891,325930,885780,315165,630597,475036,889894,748355,362240,765939,642610,443423,812284,596850,894205,412622,224796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]