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` = 40573 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40573 [ RunTime:0.002996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715802,907468,97087,29316,287269,149956,822464,513284,459259,723210,923217,778788,384970,393173,302913,640243,995716,41400,880769,41863,851572,793825,368863,992545,211765,356592,357053,396506,1910,204851,462340,555147,442940,665656,33462,847163,385168,538937,344948,1044368,88434,152734,756221,575303,372840,348640,509676,229098,970310,1029610,374511,568005,412068,662543,617042,718554,706143,67302,626185,633048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]