SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458897 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458897 [ RunTime:0.006312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932517,291490,658477,417801,88998,572681,855438,799030,68521,1007957,242669,97944,899488,280991,550406,466056,479323,127454,370484,98375,949763,829550,265075,9987,795725,500482,839776,842874,595422,254507,428839,918680,434474,1008701,399290,480475,371859,161392,477411,937470,544715,45211,121470,881526,161102,732305,363481,347038,391412,127439,908191,749896,289478,967053,791375,909277,821104,77490,202324,31401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]