SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451200 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451200 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938247,815700,62201,908734,2153,64600,6475,838163,127343,1023723,617625,414796,189670,203260,589110,372509,418272,762155,606313,277701,204642,975098,1010764,957147,895809,1030997,679789,580122,298106,656014,399356,235048,961587,773064,441262,970473,41767,311990,399051,734,762121,1025114,351133,684071,446134,52066,989412,13969,935671,774252,279929,533785,1015583,749663,598159,298400,721761,802125,382956,1019472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]