SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595599 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595599 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665610,19993,11249,141734,627485,927035,762182,593464,152967,757091,171573,48306,503100,497619,216874,787118,668580,133722,463996,1033872,404288,101763,87751,209045,778538,738019,801032,153461,330566,592422,634757,179426,109477,983126,956014,730899,873327,739543,228526,694438,74980,988839,370531,522230,699764,590884,791867,861794,237187,936579,346008,59178,200810,518782,177525,84410,627206,1037602,54447,352469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]