SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415885 LIMIT 1 [ RunTime:0.000967s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415885 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125008,904430,186269,476176,736573,838869,576070,213206,640476,2795,289354,707403,911012,921314,566878,249202,29691,310613,974087,425958,184062,668119,707268,695039,27236,439737,98478,290407,367490,819610,198093,301314,183521,99183,832646,655303,597064,978552,751543,244867,160988,432250,361342,539458,328936,9978,108302,582342,47043,251267,279030,806406,31724,389160,296405,572037,761626,467821,89773,588094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002281s ]