SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178850 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178850 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101615,209543,468132,876764,624443,458041,1035325,250302,829195,996077,736671,521696,1016036,520895,453457,31540,380776,401878,855521,916928,899973,242728,542222,200842,595149,889303,946682,408453,121833,1020381,781662,938523,746012,488845,277375,1039096,973745,638547,460444,758498,64214,269434,297506,32842,24404,688277,48079,33183,250132,777486,1012044,966976,850570,192664,2190,149932,25917,626165,74607,64685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]