SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533421 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533421 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912047,378216,259736,259050,602573,644216,239266,981710,350130,609882,671961,859875,790869,473757,525576,278445,588977,841564,325109,373671,948098,768768,803448,864154,87808,756954,36303,525469,527867,600176,969217,439672,606808,270984,190304,397600,143801,411417,997788,752281,381709,614804,86948,762132,318095,814084,37576,22536,630559,114074,843312,981992,463525,461072,844800,926367,141396,523310,711858,314435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]