SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403836 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403836 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305377,474118,947642,491778,776445,940255,866553,32271,620512,975945,913473,744466,16472,108729,9007,567965,398151,29252,413190,239623,653683,451680,452206,117709,439127,896134,672652,276587,371359,876596,658278,19167,135469,978435,401193,1029641,108243,340692,665453,760713,806489,617799,199821,938235,617222,234530,583263,596474,969424,1007647,675613,241850,436368,458684,732194,915022,74754,881505,688320,848034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]