SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42909 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42909 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287158,935429,253623,822408,1034533,614756,846332,802774,215151,561118,982968,456078,711667,498429,918998,102292,930458,389436,209321,770977,801762,545002,887809,578081,487430,1035635,710837,25145,882496,948408,758211,248919,513366,927638,982365,878656,488632,468677,612239,339659,944904,700457,777975,926732,925540,237882,356824,200505,171628,493618,529560,562461,292379,927437,1025840,613416,105537,257099,136504,189689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003915s ]