SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50912 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50912 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830034,294635,264886,930136,114109,531128,904521,38389,674587,1047351,769001,290061,186914,529849,473300,322319,812455,808755,585270,369801,635702,741584,152202,329268,488453,400668,1037774,241601,715832,569652,246726,740027,584649,570024,348785,98837,911291,146671,211307,353068,885021,324351,886220,745395,652920,56167,266162,929881,688746,845100,571297,191022,846618,949285,434575,167767,557780,1011695,604458,761935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]