SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10220 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10220 [ RunTime:0.003846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88346,254916,803806,290119,952532,772858,855042,240683,358570,976519,769677,128544,662707,199064,160253,351326,830546,1017089,2324,283650,15379,695369,986063,32192,155441,656539,238675,841522,137803,1034189,159592,844164,214201,237387,694890,273239,222511,501378,347119,721516,612883,607065,106392,571098,714565,1025458,277870,409147,1009975,681651,957630,238704,845445,350030,483245,269409,893986,936839,139789,360535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]