SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414331 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414331 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303128,560584,85434,728518,562192,645035,644708,402323,360381,632491,712532,595895,62076,731583,177835,238316,980497,264831,382037,106351,815256,604754,633617,99109,166268,222395,804833,322439,5998,614200,935866,234018,422121,161838,1035976,476726,656191,49689,542471,683402,932350,741141,1004080,463410,478955,267991,805480,758012,592598,81492,680801,455865,490277,29398,918875,28674,773719,649916,553980,357024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]