SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458963 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458963 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975412,174374,1000346,570725,541403,208580,312156,148029,826055,164871,633375,959222,343417,964381,650967,476307,378205,49493,752146,836411,589366,649291,689453,1032712,464292,269124,181353,794000,440648,923516,892443,742089,55279,121770,101758,847609,315574,901731,821986,255160,481964,92282,445925,351103,878081,416616,612275,477938,347362,939886,341572,605578,838917,579498,16598,867717,263212,946270,316288,1045809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]