SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281091 LIMIT 1 [ RunTime:0.001579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281091 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587740,388633,814897,195317,558771,431622,800171,46636,646755,534606,954924,577487,207344,714096,917102,535369,729533,106687,802560,588112,902872,828645,945961,69929,755756,24168,840923,252721,864748,205494,237409,346280,444123,314108,971976,77886,574537,109797,98623,497808,328768,276655,644042,76032,282837,198932,972334,497559,852597,499033,666676,314628,235027,91558,638465,649054,323255,51674,611901,698787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]