SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028972 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028972 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942255,482337,235565,504150,496181,621109,551729,210982,470518,51053,743226,981366,234943,808886,367585,33802,746825,105225,71542,203338,163636,549449,425648,14796,606312,280524,191335,480469,868313,460114,467576,728332,338574,704724,805330,342269,328291,1005151,174039,550444,310610,301698,743276,847057,634764,490560,874292,372790,305193,830430,670400,337831,663852,410663,875833,298715,853366,37366,446223,1013581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]