SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473028 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473028 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998761,135479,333600,993469,762447,799997,873004,82588,730750,419310,443501,650412,660055,948536,66387,576587,567517,946854,461866,658071,1045433,613000,372687,14806,540050,251537,837756,103250,446869,456000,323447,408575,896003,949066,8022,683532,634673,358501,242305,438680,1034141,113543,108170,133490,582579,137750,450234,558626,157101,928773,47192,552934,527606,649679,178479,906378,381299,700877,620351,252623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]