SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415406 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415406 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670446,355472,847542,737883,801175,944021,168827,935466,389042,1002933,447442,630219,137031,33281,407070,806745,20444,989718,354089,46701,983585,717440,78619,511273,727635,743853,955038,196450,596521,553539,194566,437088,268961,463539,639139,1011097,666848,610662,133509,461323,412956,791913,49684,186478,880153,840576,1040479,325507,780202,168279,89326,521995,401962,365285,536752,609860,547688,88741,6316,906449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]