SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544935 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544935 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862245,308117,7744,688765,254824,68708,610927,191955,596858,1021442,456095,913360,33865,669153,771035,655853,239083,862873,827464,208794,556451,802901,266086,489113,57886,876920,735239,169265,358308,976523,498703,4321,224785,794525,231680,757449,704480,566125,594600,1034337,643785,562286,1996,677101,234405,797872,821370,1043914,347165,825204,1025760,564233,988323,822650,964452,892925,595104,226107,111746,79411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]