SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861511 LIMIT 1 [ RunTime:0.001119s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861511 [ RunTime:0.001415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106001,545865,52980,122215,170901,535533,977869,842169,977496,107846,262181,60075,382235,236924,362577,799625,702848,735438,131815,249692,639742,200134,676423,624659,755841,561987,479510,635876,107683,558164,315848,622679,153622,722180,868056,366844,866984,74250,494096,296413,247945,33863,368,909094,168883,279439,694432,349502,750214,87462,59822,372683,70401,640087,209748,258711,413633,971722,347822,404794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]