SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343335 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343335 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355987,708669,939196,495754,985235,837152,199627,512525,585985,899202,486096,234602,220463,60059,190959,855936,970298,703305,337021,974158,88079,326516,208858,151454,777133,1018334,357407,187317,42463,842949,20079,152692,391147,1029342,996328,202114,808876,993695,647274,355336,408379,864141,288724,668318,760024,990878,43681,226283,141209,791431,672332,666134,19172,984646,450647,351187,120215,212301,980086,535583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]