SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022770 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022770 [ RunTime:0.003770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565713,855233,844292,320467,836880,1034595,915039,817077,646958,571385,579766,592276,909525,755164,974881,498015,167908,141213,147952,186615,327272,389594,739113,234720,634567,499042,124048,906351,707290,64756,855417,161929,791163,74101,540334,688450,806891,702832,764142,305930,257928,676684,610799,1015524,421064,481307,807865,994159,343865,134620,879343,803070,546505,877132,296528,393572,778400,764647,124129,594211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]