SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302038 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302038 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509895,491216,235806,130400,263901,472239,341143,553814,536054,547817,72674,735180,128045,856220,549199,703334,246544,102448,110761,123385,725152,606775,361220,610222,65717,528204,638600,564339,849521,671244,637701,170140,574450,348540,388996,76737,157799,486706,428376,899678,189570,318029,1000920,651931,34595,778515,674711,741726,995335,607000,177062,355634,841247,863651,443225,144869,1020347,1011794,147394,410087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]