SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404072 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404072 [ RunTime:0.003338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525345,707325,907390,487010,239353,922655,192466,399560,68686,223815,867227,255701,152184,319250,270692,743990,345950,907042,196126,459773,616865,72583,728071,970876,819079,947185,935537,60796,755115,805311,64977,300648,700950,740585,389904,708754,328524,470580,886309,499150,700210,984315,179993,451729,206288,693388,759028,247442,1038798,144328,130287,119663,279329,16593,816948,873945,351215,985206,76209,411922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003022s ]