SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28145 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28145 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190380,1001799,845475,211050,440488,82502,175225,136320,419996,291694,853768,691224,488484,161258,931522,1009789,859254,1001369,325917,215212,911119,427871,58816,887337,956045,352638,186639,807304,802982,699515,758143,640330,428828,183531,49757,614984,588997,248589,656478,766328,964479,270360,110093,495349,170626,209282,612440,1036891,190123,724462,577719,207928,940543,686968,925786,875280,603014,995456,8558,169916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]