SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107415 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107415 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613331,357158,712466,1012561,93990,715650,353383,775584,842836,964804,178696,297559,103071,274892,675433,913961,871843,59063,102558,1000715,337576,236143,995592,964224,477414,424576,214451,672685,175032,44956,344019,571206,267493,975988,3944,584558,681908,163508,784845,109731,189272,464516,783717,767712,627699,910051,902155,644159,62147,64441,190148,456546,575615,639247,806964,124635,350500,174781,92689,977759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]