SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544084 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544084 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54886,169594,358077,561312,29883,743728,685729,303519,685626,738685,957617,140656,314043,664758,684273,567487,815671,441149,397169,723100,320506,1019697,958217,201408,451751,369131,800443,133569,493356,996648,237158,895798,878212,267620,388656,870141,842163,498277,464539,260523,936049,867564,10805,998560,1009631,146885,951794,575940,378668,716414,389430,655136,836029,820099,358640,901255,768646,110252,895644,683781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]