SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431124 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431124 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765471,676170,1032361,224714,354791,296133,801917,787568,321740,980059,719916,970666,240823,102418,140745,88458,867805,863080,442651,322874,287680,415943,45250,1040735,745509,582546,143943,848271,314733,125585,722500,783091,179503,13394,364233,734788,137034,330739,63478,602750,786384,127421,208711,141084,1005708,931618,875703,823744,277801,696995,994823,789637,862513,440010,614509,1016089,256408,811927,388921,254814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]