SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312046 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312046 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580151,789347,496290,488257,659743,467133,792998,119260,851910,744378,439122,387706,846330,511622,483877,49507,931409,544814,998620,183124,842453,387956,772342,784546,554825,271769,786197,466368,82396,331478,421388,737266,637306,30785,612275,774230,44385,89369,994157,624211,583572,251807,96937,136182,342558,801129,711824,961921,141025,24674,817792,458795,79256,759603,317829,559491,1003100,273024,252390,1045040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]