SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507330 LIMIT 1 [ RunTime:0.001603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507330 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537098,882800,642531,801367,613663,697294,333188,761105,885910,40610,901897,88004,388940,715029,263243,590925,939193,406736,306520,998971,656315,379029,809276,714391,586525,152198,688495,592899,513691,301549,868261,641244,968408,85568,334544,836613,912383,95136,673654,390241,292945,40494,360437,869398,461685,642659,35579,829440,643550,723804,632900,759129,985383,947883,492708,32946,263466,656538,367737,621698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]