SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423489 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423489 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727721,497349,368407,891238,391231,822989,941889,1009572,162076,685811,793665,387747,453723,533073,348045,888396,396689,865747,433641,361683,145604,328789,831087,527167,281767,716010,195333,1038971,287857,434350,804177,41490,131757,722908,835426,67799,148039,102519,968823,962927,458740,16464,65044,973791,295869,578820,763644,756212,958941,110483,294414,323135,762007,276139,357993,70854,570941,741512,188892,886813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001145s ]