SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287012 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287012 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634281,42848,193819,22853,167836,170866,1023420,854421,530006,364079,861816,285130,428264,582210,662118,403597,202800,177593,51325,822583,578970,367266,974832,798724,904788,627411,66255,727363,879544,691419,113733,531496,813684,701060,580569,302095,846339,272484,338559,318577,101641,775376,734775,205494,539609,739867,877473,804000,849051,510927,446818,212852,252927,269224,314225,792320,716459,1004096,237636,1010498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]