SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560535 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560535 [ RunTime:0.004457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936858,861271,160679,248329,160604,772859,495488,945613,408387,129760,315018,54601,1044146,170202,853834,457258,587666,181278,811277,71518,394459,595930,651613,515149,813640,181550,697834,665077,653673,461521,91596,859442,398702,750412,177619,68950,533721,1047478,922741,302582,270945,478994,595518,125259,421812,122117,602882,173262,179625,972205,185047,309902,769316,346440,598351,555366,91202,517947,451476,222319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]