SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570857 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570857 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752932,349525,453865,930159,537600,189357,88347,604214,594224,698644,317864,756587,516093,77669,900178,495957,181804,468834,936722,615808,535077,139145,196406,348303,218516,176202,871015,969187,1029735,93561,1037560,1014677,924257,922176,933383,383403,914940,16697,770871,229206,34673,16460,207537,879557,239072,24676,561365,382681,690578,368668,1026381,87929,398842,438742,246579,204680,523819,243031,101545,537449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]