SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392054 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392054 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249655,405388,958043,970070,64736,658316,20803,99079,995220,607653,945035,727724,175498,893773,907431,35578,485754,510832,503823,231359,230851,9481,699859,951356,1043247,955412,667492,243713,651091,828317,937371,365782,561068,957739,19681,411706,382318,567230,320366,734645,342747,749462,184862,808145,795172,256948,148404,433482,200348,43113,842490,21746,778780,434089,350162,289492,548439,700634,559590,12526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]