SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517018 LIMIT 1 [ RunTime:0.000972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517018 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478177,185731,316415,507827,528600,462425,143414,783254,546543,672036,301448,524460,357309,510215,18080,449559,570209,967756,532274,595558,884595,582083,911382,134101,226801,755088,409606,25548,65653,720515,227218,1006981,304367,837919,727841,965845,21570,962025,495851,59217,251513,899967,779325,83621,281983,887707,994352,746485,971343,394922,450045,451169,36235,44861,586789,286258,198103,162234,755783,392630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]