SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025028 LIMIT 1 [ RunTime:0.000619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025028 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906435,674062,713741,826074,327442,350850,332083,84868,298229,581227,711462,993098,121365,493054,360285,123524,42234,605007,413207,501462,287279,583321,229044,784690,930010,490809,429878,24938,592985,53191,4326,625759,990815,621084,251887,880084,965703,56774,588131,902813,645895,978746,911330,523156,834998,631049,757810,615746,337913,955750,81552,851951,531867,517217,860379,831713,281084,782014,178874,158338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]