SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046743 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046743 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725923,370652,469113,849611,1013139,1035284,853770,371518,356303,354040,731170,811688,312029,1038984,213536,484712,102728,253013,785846,117046,647512,279701,523034,147263,419321,790847,504671,623536,453950,704468,284255,59042,156217,184151,692410,281841,438691,648893,929234,773251,52559,917967,395844,515149,571979,274421,174875,635853,968826,640668,918871,688911,1037024,1031270,957416,616475,673374,432517,294415,421351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001185s ]