SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467975 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467975 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467860,767770,487501,61244,344993,644936,42941,62243,409531,639248,439023,479673,269567,838411,175471,312756,822280,864490,822440,353194,335033,184409,1044766,908620,386268,598809,463250,636725,98606,90495,355775,530304,589445,207177,693921,152240,1729,277417,1021774,609550,689130,133162,768295,456403,846991,932627,957308,238168,510695,979750,435435,697107,1024912,711137,201750,492494,202608,1026718,867787,770912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]