SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489522 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489522 [ RunTime:0.003839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505708,116994,1011249,299016,523343,966008,64435,147463,562476,117545,260651,361342,286601,926058,271295,275137,265215,1046064,334251,719979,254345,906152,1020004,955133,824625,255710,720974,345156,427883,471281,806637,1009513,11266,158833,435951,313404,995689,254025,660367,173210,980779,952929,25379,948541,869731,826917,24415,565040,730728,282745,247857,33793,355017,734085,7528,695261,216331,654336,771908,811671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]