SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105683 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105683 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318330,89970,241978,790669,708399,1030029,618492,364679,18046,971032,655497,431021,937572,935680,440536,585037,685790,424277,535828,141872,175771,282794,945593,583673,603954,613668,53006,413680,427567,447861,656101,712967,308852,597129,422909,53472,1010332,579015,321258,160132,106795,44788,921727,345670,638941,737588,99290,561157,312243,74112,704330,321786,948237,1038068,686576,789013,606988,54544,976474,684693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]