SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413471 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413471 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58134,430815,898207,593905,296688,954723,175390,568603,824849,871093,362426,964920,412773,863044,774969,768952,853685,497209,851803,545104,679801,221565,287338,329358,644508,854562,620540,986832,317635,592068,389382,337302,124947,232570,953324,578670,131736,54350,778131,617821,540026,68272,253477,427297,682130,612344,702570,180508,904084,112046,76448,234555,688251,806329,650628,156247,1042728,543079,568595,956470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]