SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995043 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995043 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403374,438498,190225,25112,762128,373914,402656,530076,109011,600043,761167,807214,157379,216483,88426,368862,351766,865594,271987,938013,79867,985439,737392,743953,493598,267241,369226,250417,859388,359481,206723,698298,427720,728351,695847,50273,737165,112390,639431,337308,128117,469326,117647,865880,142854,87334,782752,654023,116432,723663,997082,452083,712507,786043,107560,960208,649304,740362,857420,869077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]