SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415150 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415150 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291351,468852,744030,896897,220915,791253,118369,10901,558854,950910,874239,324930,564922,878964,496397,425859,286147,543418,270348,640651,27159,720043,829247,260900,641129,698402,411932,847562,731573,203731,173496,741353,103463,873369,374,78534,569210,313164,20807,866856,254548,227530,15915,554558,583117,417575,89177,415986,324699,614767,493326,213323,252141,15688,235355,360176,385491,888137,529530,736089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]