SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031010 LIMIT 1 [ RunTime:0.002422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031010 [ RunTime:0.004554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441396,87444,969851,374128,234499,140703,446890,107120,353154,173680,1005635,339733,654369,95649,379179,553032,709114,821741,581114,289167,821563,377252,6590,302863,434079,338526,210379,436385,316172,749852,467020,905516,297611,860606,719829,774812,812996,488995,44268,1040624,885415,76394,568504,533103,391856,271147,195953,376021,455799,244571,37380,435031,424328,545990,91127,740780,706630,1048510,358392,54453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]