SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 780796 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 780796 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436610,482303,66101,857186,617397,835037,180102,178857,985051,134213,40367,500110,112111,1041167,239887,78939,1027667,603196,182247,581947,564859,378298,961379,322697,9288,882849,580771,253907,103355,431055,408488,944233,868761,370541,684526,122477,343287,171656,847969,684991,461090,275215,438649,149983,106646,299273,521691,957305,1017275,615047,402946,645523,953697,423095,851451,527641,294987,986953,43879,236175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 780796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 780796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]