SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119618 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119618 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487978,845871,282311,705359,375005,328057,310668,989816,28553,74674,871740,7162,660651,539669,218776,24617,1005751,515164,354817,176891,999548,630168,1046015,338168,487366,348207,845045,323519,47733,467664,920017,742563,837638,527362,694942,1033642,823288,946367,112847,159884,23543,516752,807396,5130,959221,324499,467903,680045,40412,979608,334721,536481,632182,968422,921238,688541,274163,270717,456340,327521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]