SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518320 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518320 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468247,789087,250083,626724,824631,33410,184924,589661,426376,495544,1014547,533048,291186,38133,409517,167326,261968,123366,827700,495736,349722,185913,857932,262212,24409,624419,546690,442573,481607,763304,1035110,783803,46053,612261,497374,720356,850706,942018,162928,87827,892160,707370,439855,838106,113187,389820,946934,160643,383082,52139,393505,357758,126948,108864,844290,691306,72905,122537,241267,126665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]