SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154236 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154236 [ RunTime:0.003833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478810,166901,438632,753114,769188,391214,268822,295239,34297,499966,409595,283020,914980,181492,544532,960883,995152,634443,178030,661518,616621,519494,216024,748110,589680,475982,947310,1010395,889966,292790,266913,676762,318151,268460,571293,336257,586815,95693,492810,902192,642736,14304,768274,32518,51759,160275,953873,192835,505699,697603,669122,778618,792982,16474,324528,643475,694679,428388,772134,341326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]