SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517596 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517596 [ RunTime:0.003498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409351,742331,954035,108356,636656,174686,823785,442068,235096,197179,742298,223214,776038,289496,1033485,1022246,525647,891806,113057,947928,677873,900912,109878,809910,540674,110562,325090,417048,910690,611966,43653,683288,301218,996649,408949,338398,240876,988841,625039,1007929,367827,993069,66111,614540,727674,803637,337051,513395,897947,960368,945141,372157,408217,667528,730260,32140,1033530,88613,686779,382678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]