SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517044 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517044 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24917,507656,1020107,727815,670401,1037874,821309,984523,478377,931973,380604,817367,951952,271675,359635,271481,485068,794315,42929,295781,71126,283904,226341,621421,137043,503483,554336,140500,53745,354842,719326,490338,578160,730632,752013,346013,166262,948746,267689,407395,538348,695840,430189,1036896,684203,688554,450895,721734,133411,333404,425791,38728,698451,289535,171175,15036,337170,298804,112714,322980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001415s ]