SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682843 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682843 [ RunTime:0.002639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836508,902459,74382,1005468,262935,1014527,863482,327025,783130,674323,961169,67915,349223,1043709,507706,110347,273869,27449,516471,141230,231027,818458,716296,567774,676681,1009269,126908,632239,32909,1046282,869483,285433,110308,920639,588416,86113,651625,13260,592261,286,800303,287933,502229,477727,718241,462960,787065,869733,36705,672489,507499,428674,511359,421152,1047345,512057,565303,397459,541164,812070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]