SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402325 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402325 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184309,670082,88291,996319,46428,732603,41584,90915,815791,1044816,755415,212693,53716,103165,1008261,939788,796659,166914,605198,260005,444190,663829,488215,1019859,415137,124499,136109,211766,293493,725211,473310,495262,965082,877737,712730,531143,640290,149274,343796,360224,190510,442202,455681,881867,291025,282547,935171,823599,41386,65158,624896,459320,660790,647386,1002981,32776,206370,402067,15284,199118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]