SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49199 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49199 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403740,16083,426858,456547,836903,594592,430669,337967,223138,339986,507942,154952,730006,986035,777554,544700,1048796,349986,168615,674748,614520,980383,583044,5212,328765,508852,985336,76859,359379,163105,689722,104149,138767,862868,316785,787854,95433,412379,918252,185188,720190,160644,744564,258811,327392,1016732,525459,849072,214931,200765,859934,588444,633070,986133,186105,659716,547842,264573,62767,72140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]