SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030021 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030021 [ RunTime:0.008353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15743,458122,35474,240004,590991,259640,634620,807820,342745,272925,266889,278364,749551,131205,283133,52499,40837,106751,319225,97747,10821,293729,832846,789638,897808,558466,606928,1037479,275450,905522,697609,874529,875753,737020,461914,558676,883220,1006400,758883,458505,753120,879901,231543,173332,678291,901291,395089,33629,907766,625112,891958,409902,245392,761879,359597,717761,585915,873761,54830,873297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]