SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335509 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335509 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636679,444123,21404,577340,669942,52789,399197,516884,979108,224668,1012858,554575,889327,480106,663289,969530,84012,514779,1033735,357430,474386,143600,6116,126641,333989,752512,692491,437862,697146,184406,266807,1031245,904116,784475,59197,849788,125511,976524,14814,615194,6088,451960,1001634,149615,723301,966450,705884,189911,380326,769730,409418,61343,455339,739175,223065,601095,789722,1027030,311105,391513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]