SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311808 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311808 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282575,1012191,492516,824077,859945,221858,343601,167613,897085,999749,112465,19682,480280,752307,697053,502855,90603,318690,24659,92899,699618,332417,985672,976197,913115,1039151,126130,911059,164067,273823,682872,86740,157510,300667,3179,87146,485574,153625,657606,126132,913432,949892,451898,3488,306367,53445,84119,686398,431184,588841,76989,610865,870364,1749,622733,555430,1001739,227291,839371,607720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]