SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395004 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395004 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534849,350351,348176,1036674,58022,360014,32924,845072,485721,334022,798549,383208,331601,626422,121010,651191,419006,228420,802799,90947,61900,763400,114548,379596,487360,815427,452662,110387,736287,398359,648714,536867,111208,58337,620823,288944,1004764,789468,110140,835283,716932,620970,876935,207936,866642,195970,558921,837742,872910,950771,281805,915242,473020,398045,354346,364940,309912,462589,492078,673446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]