SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027588 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027588 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512154,1045971,1045976,220307,246369,847149,459606,422356,653893,857059,596993,581226,358891,718607,778186,584947,743586,203437,825883,353513,600816,784927,339175,354359,61101,892307,81512,2125,222,1019120,251429,342845,930142,901754,211613,704006,709222,567332,774665,221740,538867,224790,182513,449477,272893,312862,989980,302043,64214,656411,269567,978324,549140,849767,255188,56089,7537,1032673,251853,75776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]